<?
if (($Results = $Cache->get_value('better_single_groupids')) === false) {
	$DB->query("
		SELECT
			t.ID AS TorrentID,
			t.GroupID AS GroupID
		FROM xbt_files_users AS x
			JOIN torrents AS t ON t.ID=x.fid
		WHERE t.Format='FLAC'
		GROUP BY x.fid
		HAVING COUNT(x.uid) = 1
		ORDER BY t.LogScore DESC, t.Time ASC
		LIMIT 30");

	$Results = $DB->to_pair('GroupID', 'TorrentID', false);
	$Cache->cache_value('better_single_groupids', $Results, 30 * 60);
}

$Groups = Torrents::get_groups(array_keys($Results));

View::show_header(Lang::get('better', 'single_seeder_flacs'));
?>
<div class="linkbox">
	<a href="better.php" class="brackets"><?= Lang::get('better', 'back_to_better_php_list') ?></a>
</div>
<div class="thin">
	<div class="table_container border">
		<table width="100%" class="torrent_table">
			<tr class="colhead">
				<td><?= Lang::get('better', 'torrent') ?></td>
			</tr>
			<?
			foreach ($Results as $GroupID => $FlacID) {
				if (!isset($Groups[$GroupID])) {
					continue;
				}
				$Group = $Groups[$GroupID];
				extract(Torrents::array_group($Group));
				$TorrentTags = new Tags($TagList);

				if (!empty($ExtendedArtists[1]) || !empty($ExtendedArtists[4]) || !empty($ExtendedArtists[5]) || !empty($ExtendedArtists[6])) {
					unset($ExtendedArtists[2]);
					unset($ExtendedArtists[3]);
					$DisplayName = Artists::display_artists($ExtendedArtists);
				} else {
					$DisplayName = '';
				}

				$DisplayName .= "<a href=\"torrents.php?id=$GroupID&amp;torrentid=$FlacID\" class=\"tooltip\" title=\"" . Lang::get('global', 'view_torrent') . "\" dir=\"ltr\">$GroupName</a>";
				if ($GroupYear > 0) {
					$DisplayName .= " [$GroupYear]";
				}
				if ($ReleaseType > 0) {
					$DisplayName .= " [" . $ReleaseTypes[$ReleaseType] . "]";
				}

				$ExtraInfo = Torrents::torrent_info($Torrents[$FlacID]);
				if ($ExtraInfo) {
					$DisplayName .= ' - ' . $ExtraInfo;
				}
			?>
				<tr class="torrent torrent_row<?= $Torrents[$FlacID]['IsSnatched'] ? ' snatched_torrent' : '' ?>">
					<td>
						<span class="torrent_links_block">
							<a href="torrents.php?action=download&amp;id=<?= $FlacID ?>&amp;authkey=<?= $LoggedUser['AuthKey'] ?>&amp;torrent_pass=<?= $LoggedUser['torrent_pass'] ?>" title="<?= Lang::get('better', 'download') ?>" class="brackets tooltip">DL</a>
						</span>
						<?= $DisplayName ?>
						<div class="tags"><?= $TorrentTags->format() ?></div>
					</td>
				</tr>
			<?	} ?>
		</table>
	</div>
</div>
<?
View::show_footer();
?>